package com.qdu.mapper;

import com.qdu.entity.Houseinfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.security.core.parameters.P;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface HouseinfoMapper {
    int deleteByPrimaryKey(String hid);

    int insert(Houseinfo record);

    int insertSelective(Houseinfo record);

    Houseinfo selectByPrimaryKey(String hid);

    List<Houseinfo> selectByUid(String uid);

    int updateByPrimaryKeySelective(Houseinfo record);

    int updateByPrimaryKey(Houseinfo record);

    List<Houseinfo> getByKey(String keys);

    List<Houseinfo> getByLotsKeys(@Param("mode") String mode, @Param("pricelow") int pricelow,@Param("pricetop") int pricetop,@Param("type") String type,@Param("term") int term,@Param("floorlow") int floorlow,@Param("floortop") int floortop);//mode出租方式，price租金，type户型，term租期，floor楼层

    List<Houseinfo> getAll();

    List<Houseinfo> getHouseByPage(@Param("start") Integer start, @Param("rows") Integer rows);

    Long findTotals();
}